create external table jms_dim.dim_tab_platform_forecast_ord_cfg_base_dt
(
  date_time            string   comment  '预测日期'
  ,source_code          string   comment '平台 tb.pdd,ks,dy,other'
  ,forecast_waybill_cnt string   comment '预测单量'
  ,version_flag         string   comment '增幅版本 2021,2022'
  ,is_confirm           string   comment '是否确认'
  ,confirm_time         string   comment '确认时间'
)
COMMENT  '大促预测配置表'
PARTITIONED BY (dt STRING COMMENT '时间分区')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dim.db/external/dim_tab_platform_forecast_ord_cfg_base_dt'
TBLPROPERTIES (
'discover.partitions' = 'false',
'parquet.column.index.access' = 'true'
);